package com.our.dao;


import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.mybatis.spring.annotation.MapperScan;


import com.our.model.UserPro;
@MapperScan
public interface UserProMapper {
    int deleteByPrimaryKey(Integer upId);

    int insert(UserPro record);

    int insertSelective(UserPro record);

    UserPro selectByPrimaryKey(Integer upId);

    int updateByPrimaryKeySelective(UserPro record);

    int updateByPrimaryKey(UserPro record);

	Object sumInvestMoney(String str);
	
	List<UserPro> selectTopList(String str);
	
	int updateStatement();

	
	Double sumForInvestOfMonth(@Param("beginTime") Date beginTime,@Param("endTime") Date endTime);

	Object sumTotalProfit(String str);

	Double sumForProfitOfMonth(@Param("beginTime")Date beginTime,@Param("endTime") Date endTime);

    
    List<UserPro> selectAll();

	List<UserPro> selectByUserId(int userId);

	void updateStatement(String date);
	
	List<UserPro> selectByProId(int proId);
	
	List<UserPro> findInvestByUserName(String UserName);

}